Invoice

%3CLINGO-SUB%20id%3D%22lingo-sub-1091132%22%20slang%3D%22en-US%22%3EInvoice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091132%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20do%20i%20need%20to%20make%20sale%20invoice%2C%20what%20do%20i%20need%20to%20make%20like%20SharePoint%20List%20and%20how%20can%20i%20set%20it%20up%20i%20mean%20SharePoint%20list%26nbsp%3B%20in%20which%20way%20shall%20i%20set%20up%20please%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1091132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091344%22%20slang%3D%22en-US%22%3ERe%3A%20Invoice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324358%22%20target%3D%22_blank%22%3E%40RAMOLE1325%3C%2FA%3E%26nbsp%3Bthe%20setup%20of%20the%20SharePoint%20list%20could%20be%20like%20this%3A%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20643px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163833i30D2E980D4D7D086%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220-SP-list-columns.png%22%20title%3D%220-SP-list-columns.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20your%20form%20you'd%20just%20enter%20what%20the%20invoice%20was%20for%20(in%20the%20title%20column)%2C%20lookup%20the%20customer%26nbsp%3B%20and%20enter%20the%20Unit%20cost%20and%20amount%20purchased.%20The%20other%20columns%20would%20be%20entered%20automatically%20when%20you%20saved%20the%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20always%20invoicing%20for%20the%20same%20things%20then%20you%20could%20have%20a%20separate%20list%20for%20the%20item%20and%20the%20unit%20cost%20and%20do%20a%20lookup%20for%20those.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20then%20using%20Power%20Automate%20to%20create%20the%20invoice%20file%20and%20send%20it%20to%20the%20customer%20you%20would%20need%20the%20txt...%20calculated%20columns%20because%20otherwise%20Power%20Automate%20puts%20in%2011%20extra%20decimal%20places%20on%20calculated%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163832i13D81B28A2786B01%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221-SP-list.png%22%20title%3D%221-SP-list.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3C%2FP%3E%3CP%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091710%22%20slang%3D%22en-US%22%3ERe%3A%20Invoice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091710%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20use%20invoicing%20for%20the%20same%20things%20and%20i%20have%20products%26nbsp%3Bseparate%20list%20which%20contains%26nbsp%3Bthe%20unit%20price%20also%20how%20can%20i%20do%20the%20calculation%20or%20if%20you%20have%20a%20demo%20or%20show%20me%20how%20which%20i%20can%20fellow%20please%20as%20i%20tried%20but%20i%20am%20unable%20to%20do%26nbsp%3Bit%2C%20please%20.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20Rob%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All,

 

what do i need to make sale invoice, what do i need to make like SharePoint List and how can i set it up i mean SharePoint list  in which way shall i set up please 

 

Thanks 

2 Replies

@RAMOLE1325 the setup of the SharePoint list could be like this: 

0-SP-list-columns.png

 

In your form you'd just enter what the invoice was for (in the title column), lookup the customer  and enter the Unit cost and amount purchased. The other columns would be entered automatically when you saved the form.

 

If you are always invoicing for the same things then you could have a separate list for the item and the unit cost and do a lookup for those.

 

If you are then using Power Automate to create the invoice file and send it to the customer you would need the txt... calculated columns because otherwise Power Automate puts in 11 extra decimal places on calculated columns.

 

1-SP-list.png

 

Rob

Los Gallardos
Microsoft Power Automate Community Super User

Hi@RobElliott 

 

I use invoicing for the same things and i have products separate list which contains the unit price also how can i do the calculation or if you have a demo or show me how which i can fellow please as i tried but i am unable to do it, please .

 

Thanks Rob