Macro to adjust receipts and invoices on FIFO Basis

[amandeep08]

Dear All,

I want a macro that will calculate the data based on below table (Customer Wise) and provide the results on FIFO Basis.

On one side, i have receipts and on another side, i have invoices. I have given example with remarks on the requirement. Can someone help here

FIFI Adjustment.xlsx
	D
1
Sheet1

 

[vw412]

Sorry but you did not give a good picture of your sheet. No idea what you need or how to help you at this point.

 

[amandeep08]

Sorry but you did not give a good picture of your sheet. No idea what you need or how to help you at this point.

Sir,

Sorry if the fie is confusing. Let me explain you:

There are 2 sheets - one is receipts and other one is invoice. We need to knock off the receipts with invoices (CLIENT WISE) on FIFO basis. Now the issue is that if the 1st receipt amount is less than 1st Invoice, we have to show the receipt amount (Actual Amount) and agsint that, same amount will be shown as invoice amount. Balance amount of 1st invoice will be shown against 2nd receipt.

In the file attached now, 1st receipt is of 50K while 1st invoice will be of 1.58 Lacs. Now the first line item that will be created is 1st receipt of 50K and 50K invoice only with invoice and receipt details.

2nd receipt is of 3.58 Lacs and 2nd invoice will be of 3.58 only. Now 3.58 receipt will be split into 2 parts. 1st it will adjust the pending amount of 1.08 Lacs which is pending from 1st line item and macro will create another line item of balance amount and that will be adjusted against 2nd invoice and so on.

This will be done customer wise. Hope this clarifies.

FIFI Adjustment.xlsx
	A
1	Receipts
Sheet1

 

[vw412]

I must repeat my last post, I cannot tell from the picture what the worksheet looks like. Can you upload a representative workbook to a file sharing service like Dropbox then post a link to it here so we can look at it better? I think I understand what you want to do but need to workbook to help you.

 

[amandeep08]

Sir

I must repeat my last post, I cannot tell from the picture what the worksheet looks like. Can you upload a representative workbook to a file sharing service like Dropbox then post a link to it here so we can look at it better? I think I understand what you want to do but need to workbook to help you.

,
Pl find the google link of the file attached

Google Drive: Sign-in

Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).

drive.google.com

 

[amandeep08]

Sir

,
Pl find the google link of the file attached

Google Drive: Sign-in

Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).

drive.google.com

I must repeat my last post, I cannot tell from the picture what the worksheet looks like. Can you upload a representative workbook to a file sharing service like Dropbox then post a link to it here so we can look at it better? I think I understand what you want to do but need to workbook to help you.

Sir,
Any update

 

[rdavuluri44]

hi, pls share if you found a resolution for this
i'm stuck with same task