Reverse the purchase order invoice with invoice journal

(0) Share

Report

Posted on by Community Member

Hi there,

if the client post the purchase order invoice with wrong date accidentally(amount is correct), it will have impact on the report since the posting date is wrong.

The inventory will be reversed as well if i use the "Credit Note" witch is not what i want, so what i'm thinking is reversing the invoice transaction by two invoice journal.

1. Post a "invoice journal" with same amount and date but reversed value.(to reverse the wrong date voucher)

2. Post another "invoice journal" with the same amount and the right date.

Is there any other way to fix this problem or any potential issue with my work-around ?

many thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Reverse the purchase order invoice with invoice journal

Hi Jiannui,

Don't book directly on these accounts because they are the check on your subledger administrtaion (supplier and stock) My point is that I don't know which kind of report we are talking about, but this is not something that will influence your profit and loss. If you need to remove the supplier from the list of suppliers: open a ledgerjournal, select the original invoice, settle the amount with a ledger account anything in your balance except these. Then open a second journal, do the opposite booking in the next period for this supplier with the same ledgeraccount you selected in the first.

I am sorry I can't show you with print screen, but I don't have AX at my disposal at the moment.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Reverse the purchase order invoice with invoice journal

[quote user="Carla@EPS"]

Hi Jiannui,

1 Beware that the ledger for receipts probably is blocked, so you can't use the same ledger on a the journal.

2 If it is a product receipt it wouldn't effect the report that much because with your action you only would move one balance ledger to another balance ledger. So it won't effect the profit and loss. So instead of the ledger "Invoices to be received" the amount will be on ledger "suppliers" right?

3. Beware of possible VAT postings that are reported if applicable

Why don't you make a regular jounal ledger-ledger and reverse that one in the next period.

[/quote]

Hi Carla.

Here is the subledger entries for one of my purchase order.

Purchase Receipt

Purchase Invoice:

the lines with color are all reversed, and only "Sales tax", "Vendor balance" and "Purchase, inventory receipt" are left, so from my point of view, i only have to reverse these three main accounts by a "general journal".

then i post another general journal with the right posting date, then the report will work properly, is it right ?(the main concern is the purchase invoice posted on wrong time)

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Reverse the purchase order invoice with invoice journal

Hi Jiannui,

1 Beware that the ledger for receipts probably is blocked, so you can't use the same ledger on a the journal.

2 If it is a product receipt it wouldn't effect the report that much because with your action you only would move one balance ledger to another balance ledger. So it won't effect the profit and loss. So instead of the ledger "Invoices to be received" the amount will be on ledger "suppliers" right?

3. Beware of possible VAT postings that are reported if applicable

Why don't you make a regular jounal ledger-ledger and reverse that one in the next period.

Was this reply helpful? Yes No
Suggested answer

Mamdouh 146 on at

Like (0)

Report

RE: Reverse the purchase order invoice with invoice journal

sure,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Reverse the purchase order invoice with invoice journal

[quote user="Mamdouh Fahim"]

Hi Ding,

I think your work around will fix this issue , but consider that this solution will only affect the financial date and still the physical date (inventory date) will be wrong

[/quote]

HI Mandouh,

I think the "Product Receipt" is posted on the correct time, only the invoice date is not correct, so i think only the financial voucher should be reversed, right ?

Was this reply helpful? Yes No
Suggested answer

Mamdouh 146 on at

Like (0)

Report

RE: Reverse the purchase order invoice with invoice journal

Hi Ding,

I think your work around will fix this issue , but consider that this solution will only affect the financial date and still the physical date (inventory date) will be wrong

Was this reply helpful? Yes No