Recently I got a modification request where user wanted to Auto calculate the backorder qty on a sales order. as they don't wish to calculate the backorder qty on partial shipments.
The example they come up with have Sales Order with line item of 100 pcs, ship 20 pcs, 80 pcs should be the calculated backorder.
the next time item needed to ship (Order Qty) is 20 pcs so they want backorder qty to auto calculate to 60
At this point user can also partially transfer order to invoice.
For this requirement we come up with a solution, to add a field 'QTY Ship' on sales transaction entry window.
User need to enter the Ship qty and on saving order it will automatically calculate the back order quantity. To cover the functionality of auto calculation of back order quantities the functionality was added on Save button, Transfer button and print button, as user can print and transfer order to invoice any time. For this eConnect was used to keep the business logic correct.
-- Link back to similar customization --
Quantity update issue with eConnect
eConnect and SOP10200.QTYTBAOR and SOP10200.QTYPRBAC
#MSDynGP,#dynamics,#erp,#businesscentral,#microsoftdynamics,#microsoftdynamicsax#PowerApps
Pages
- Home
- Hire the best Microsoft Dynamics GP Freelancer
- Get Quote VBA to Sanscript(Dexterity)/VSTools
- What People Asked
- Testimonials
- Example: How to Open URL from .Net from inside of Dexterity Code.
- Dynamics GP C# Integration: RMCustomerAddress
- How to verify inactive employee on Time Card Entry Window
- Cash Receipt Window: Stop user to delete receipts
- Sales Transfer Document , Include Total and Deposits
- Looking for GP Tables?
- Deployment Steps For Travelers report
- How to create Test GP folder for tetsing dexterity changes.
Total Pageviews
Subscribe to:
Post Comments (Atom)
Some of my Dynamics GP freelance work
- Home
- eConnect: Payables Transaction Entry Distribution
- eConnect: Vendor EFT Bank Maintenance
- Another eConnect task for Payable Transaction Tax Assignment
- Manufacturing Traveler Report with Components - Component Sort Order
- Auto Calculate Back Order Quantities
- Adding 2 new fields to FA PO Additional Information Window
- Cashbook Bank Management Cash Receipt : Post transaction before printing.
- What if I only have chunk and not the source code! can you upgrade for newer version?
- Sales Quote Form Report: group by Item Class.
- Payables Historical Aged Trial Balance - SQL Script
- Modifying Smartlist Customer and Vendor Lookup
- Dynamics GP C# Integration: RMCustomerAddress
.
My Learning Resources
!doctype>
No comments:
Post a Comment
Your Comments