Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Modify Posting Date
slmaluwa
Member Posts: 366
hi
When making Sales Orders, the posting date is recorded as WORKDATE. But, in some instances, the user try to post it after few days of creating the order.
I am trying to modify the Posting Date to current date at the time posting in Sales Order "Post".
Here is what I do
1. If the Posting Date is different, ask the user whether would like to change
2. If yes, I do
Posting Date := TODAY;
VALIDATE("Posting Date");
Shipment Date := TODAY;
VALIDATE("Shipment Date");
MODIFY
and then carry on the posting. and it is seems to be working.
Can some experts tell me whether I am doing the current way? Is there any thing else to do?
TIA
Maluwa
When making Sales Orders, the posting date is recorded as WORKDATE. But, in some instances, the user try to post it after few days of creating the order.
I am trying to modify the Posting Date to current date at the time posting in Sales Order "Post".
Here is what I do
1. If the Posting Date is different, ask the user whether would like to change
2. If yes, I do
Posting Date := TODAY;
VALIDATE("Posting Date");
Shipment Date := TODAY;
VALIDATE("Shipment Date");
MODIFY
and then carry on the posting. and it is seems to be working.
Can some experts tell me whether I am doing the current way? Is there any thing else to do?
TIA
Maluwa
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
0
Comments
On the form (order, invoice, etc.) you could put this code: You don't write this to the database! Only the value on the form is changed. When the users wants to post this order, the standard error message is displayed because the Posting Date is blank. Now the user has to fill in the field, before he can post the document.
Note that in NAV 5.0 SP1, one has a new option to have this Posting Date filled in or not by default in Sales & Purchase documents.
In our case, we have already disabled editing the Posting Date for some other reasons.
So, user cannot change it by typing it.
by the way, I hope my method mention above is correct. What will happen when I change this info for a partially posted Order?
Anyway, where did you put your code? CU80? Just make sure that all functionality still works (manual invoice, batch posting, inventory Pick posting,...) normally same process is passed, but better check it out!
You did not get any message on order-status while modifying the record?
I'rm not a programmer, but VALIDATE("Posting Date",today); should work also.
Succes!