SOLVED

Inventory sheet problem

%3CLINGO-SUB%20id%3D%22lingo-sub-359319%22%20slang%3D%22en-US%22%3EInventory%20sheet%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359319%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20make%20a%20daily%20sale%20report%2C%20and%20I'm%20having%20a%26nbsp%3B%20problem%20making%20one%20day%20closing%20inventory%20into%20next%20day%20opening%20inventory%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359319%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359377%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20sheet%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359377%22%20slang%3D%22en-US%22%3Ethank%20you%20for%20the%20format.%20it%20was%20very%20helpful%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359360%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20sheet%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359360%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F294055%22%20target%3D%22_blank%22%3E%40Amjad-Bashir745%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20Is%20your%20Data%20download%20from%20any%20e-commerce%20sites%3F%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3E2)%20you%20are%20using%20manual%20inventory%20sheet(Format).%3C%2FP%3E%3CP%3Eif%20you%20have%20manual%20inventory%20sheet(Format).%3C%2FP%3E%3CP%3EThen%20I%20modified%20format%20and%20attached.%20hope%20it%20helpful%20for%20you.%3C%2FP%3E%3CP%3Eif%20not%20let%20me%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3ENaveen%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359354%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20sheet%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22first%20day%20report%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84894iF5FAF5767205044B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22capture.PNG%22%20alt%3D%22first%20day%20report%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Efirst%20day%20report%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22second%20day%20report%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84895iE12657A4EAD37CB6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture%20(1).PNG%22%20alt%3D%22second%20day%20report%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Esecond%20day%20report%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3EPlease%20provide%20a%20sample%20of%20the%20layout%20of%20your%20data%20and%20the%20closing%20inventory%20to%20be%20forwarded%20as%20opening%20inventory%20for%20the%20next%20day.%20Units%20of%20inventory%20are%20easy%20to%20calculate%20but%20the%20costs%20thereof%20are%20not%20easy%20for%20being%20dependent%20upon%20the%20cost%20flow%20assumption%20that%20you%20adopt.%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3Ethis%20report%20is%20not%20meant%20to%20calculate%20the%20cost%20of%20the%20inventory%20but%20for%20the%20units%20of%20the%20inventory%20itself%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359347%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20sheet%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359347%22%20slang%3D%22en-US%22%3EPlease%20provide%20a%20sample%20of%20the%20layout%20of%20your%20data%20and%20the%20closing%20inventory%20to%20be%20forwarded%20as%20opening%20inventory%20for%20the%20next%20day.%20Units%20of%20inventory%20are%20easy%20to%20calculate%20but%20the%20costs%20thereof%20are%20not%20easy%20for%20being%20dependent%20upon%20the%20cost%20flow%20assumption%20that%20you%20adopt.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Trying to make a daily sale report, and I'm having a  problem making one day closing inventory into next day opening inventory

 

4 Replies
Highlighted
Please provide a sample of the layout of your data and the closing inventory to be forwarded as opening inventory for the next day. Units of inventory are easy to calculate but the costs thereof are not easy for being dependent upon the cost flow assumption that you adopt.
Highlighted

first day reportfirst day reportsecond day reportsecond day report


@Twifoo wrote:
Please provide a sample of the layout of your data and the closing inventory to be forwarded as opening inventory for the next day. Units of inventory are easy to calculate but the costs thereof are not easy for being dependent upon the cost flow assumption that you adopt.

this report is not meant to calculate the cost of the inventory but for the units of the inventory itself

Highlighted
Solution

Hi @Amjad-Bashir745 ,

 

1) Is your Data download from any e-commerce sites?

or

2) you are using manual inventory sheet(Format).

if you have manual inventory sheet(Format).

Then I modified format and attached. hope it helpful for you.

if not let me know.

 

Best Regards,

Naveen

 

 

 

Highlighted
thank you for the format. it was very helpful