Microsoft Dynamics AX (Archived)

Product receipt date should be less than vendor Invoice date

(0) Share

Report

Posted on by agus

1,174

Hi expert,

is there any setup in AX 2012 CU 9 for my case, Product receipt date should be less than vendor Invoice date ?

because there is un match amount between ledger and accrued purchase report (procurement & sourcing>>report >>status) because of this scenario.

for example :

product receipt date november 17, 2015

Invoice date november 16 2015

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please always use a description title ("hi ex" doesn't belong to this category) and attach appropriate tags.

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report
Copy link

Link copied!

hi martin,

thanks for revision. I did not notice it.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Agus,

There is no automatic Feature/Parameter or something alike that can prevent users from backdating transactions. The only Thing that can help for posting into previous periods is closing the periods.

Yet, I am wondering what your Problem is. Can you provide some additional Detail?

Ludwig

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report
Copy link

Link copied!

hi Ludwig,

my scenario is, enter product receipt on 17 November 2015 and posted, then I display report accrued purchase ((procurement & sourcing>>report >>status)) on 17 nov 2015, data appear.

I create vendor invoice on 16 November 2015 (wrongly input date),then display again report accrued purchase ((procurement & sourcing>>report >>status)) on 17 nov 2015. data does not appear.

so that I need to protect vendor invoice date value.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Agus,

Thank you for the information.

Yet, as I said AX has no automatic feature that could prevent such wrongly input...

Regards,

Ludwig

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report
Copy link

Link copied!

does it mean I should make some customize to validate for may scenario ?

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

your question should be other way like

"Invoice Date should be greater than Product Receipt Date"

It is not possible to know invoiceDate, at time of Receipt

even a developer will understand it better, if you will give him for development.

else, he may not start coding at ProductReceipt and trying to find InvoiceDate, where nothing has been invoiced yet.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Agus,

In my opinion this is the only chance you have.

Yet, really weight the advantages and disadvantages (costs) of such an adjustment if this is really required and cannot be avoided e.g. by training users. You also need to consider implications that such an adjustment might have on other automatic processes (inventory close, ...). It can happen that your adjustment blocks/stops other processes...

I would try avoiding such an adjustment but that's something you need to assess and decide.

Ludwig

Was this reply helpful? Yes No
Verified answer

agus 1,174 on at

Like (0)

Report
Copy link

Link copied!

thanks guys for your help

Was this reply helpful? Yes No