Move AR Records from History to Open – Reversing Apply ( After Paid Transactions Removal )

The apply process in Dynamics GP is different between the receivable and the payable modules when payable transactions are fully applied they are “automatically” moved to history which means that the data is migrated from the open tables into the history tables. On the other hand, this is not the same behavior of the receivable module, in which fully applied documents are not moved to history at all unless a specific routine in the system which is called “Paid Transactions Removal” is run, upon which, the documents are moved from the open table to history.

Apply Reversal

Due to the different behavior of the modules illustrated above, AR transactions can be applied and un-applied at any time provided that the “paid transaction removal” process is not run. On the other hand, this is not the case in the payable module, because historical transactions cannot be un-applied using the “Apply” function, but it requires specific steps initiated by “voiding” the payment and releasing the invoices.

AR – Move History to Open ( Yes, History to Open … Reversing Apply ) – After Running Paid Transactions Removal

In certain cases, the apply processes get interrupted and result with damaged applied records, in case the records have been moved to history, then records are stuck in the history tables, but in fact, the document is not fully applied

In this essence, I have developed a procedure in order to reverse the apply process and release the sales invoices documents by moving the records fro the history status to the open status. Below is the detailed steps on how to run this procedure:

— Change the Status of Sales Documents, from History to Open
SELECT * FROM RM00401
WHERE DOCNUMBR IN ( ‘XXXX’ )

— Replace ‘XXXX’ With the Sales Document which requires to be Released ( History to Open )

–UPDATE RM00401
–SET DCSTATUS = 2
–WHERE DOCNUMBR IN ( ‘XXXX’ )
— MOVE RM Records From OPEN TO History
INSERT INTO dbo.RM20101
(
   
CUSTNMBR
,
   
CPRCSTNM
,
   
DOCNUMBR
,
   
CHEKNMBR
,
   
BACHNUMB
,
   
BCHSOURC
,
   
TRXSORCE
,
   
RMDTYPAL
,
   
CSHRCTYP
,
   
CBKIDCRD
,
   
CBKIDCSH
,
   
CBKIDCHK
,
   
DUEDATE
,
   
DOCDATE
,
   
POSTDATE
,
   
PSTUSRID
,
   
GLPOSTDT
,
   
LSTEDTDT
,
   
LSTUSRED
,
   
ORTRXAMT
,
   
CURTRXAM
,
   
SLSAMNT
,
   
COSTAMNT
,
   
FRTAMNT
,
   
MISCAMNT
,
   
TAXAMNT
,
   
COMDLRAM
,
   
CASHAMNT
,
   
DISTKNAM
,
   
DISAVAMT
,
   
DISAVTKN
,
   
DISCRTND
,
   
DISCDATE
,
   
DSCDLRAM
,
   
DSCPCTAM
,
   
WROFAMNT
,
   
TRXDSCRN
,
   
CSPORNBR
,
   
SLPRSNID
,
   
SLSTERCD
,
   
DINVPDOF
,
   
PPSAMDED
,
   
GSTDSAMT
,
   
DELETE1
,
   
AGNGBUKT
,
   
VOIDSTTS
,
   
VOIDDATE
,
   
TAXSCHID
,
   
CURNCYID
,
   
PYMTRMID
,
   
SHIPMTHD
,
   
TRDISAMT
,
   
SLSCHDID
,
   
FRTSCHID
,
   
MSCSCHID
,
   
NOTEINDX
,
   
Tax_Date
,
   
APLYWITH
,
   
SALEDATE
,
   
CORRCTN
,
   
SIMPLIFD
,
   
Electronic
,
   
ECTRX
,
   
BKTSLSAM
,
   
BKTFRTAM
,
   
BKTMSCAM
,
   
BackoutTradeDisc
,
   
Factoring
,
   
DIRECTDEBIT
,
   
ADRSCODE
,
   
EFTFLAG
,
   
DEX_ROW_TS
)
SELECT CUSTNMBR,
      
CPRCSTNM
,
      
DOCNUMBR
,
      
CHEKNMBR
,
      
BACHNUMB
,
      
BCHSOURC
,
      
TRXSORCE
,
      
RMDTYPAL
,
      
CSHRCTYP
,
      
,
      
,
      
,
      
DUEDATE
,
      
DOCDATE
,
      
POSTDATE
,
      
PSTUSRID
,
      
GLPOSTDT
,
      
LSTEDTDT
,
      
LSTUSRED
,
      
ORTRXAMT
,
      
0
,
      
SLSAMNT
,
      
COSTAMNT
,
      
FRTAMNT
,
      
MISCAMNT
,
      
TAXAMNT
,
      
COMDLRAM
,
      
CASHAMNT
,
      
DISTKNAM
,
      
DISAVAMT
,
      
0
,
      
DISCRTND
,
      
DISCDATE
,
      
DSCDLRAM
,
      
DSCPCTAM
,
      
WROFAMNT
,
      
TRXDSCRN
,
      
CSPORNBR
,
      
SLPRSNID
,
      
SLSTERCD
,
      
DINVPDOF
,
      
PPSAMDED
,
      
GSTDSAMT
,
      
DELETE1
,
      
,
      
VOIDSTTS
,
      
VOIDDATE
,
      
TAXSCHID
,
      
CURNCYID
,
      
PYMTRMID
,
      
SHIPMTHD
,
      
TRDISAMT
,
      
SLSCHDID
,
      
FRTSCHID
,
      
MSCSCHID
,
      
NOTEINDX
,
      
Tax_Date
,
      
APLYWITH
,
      
SALEDATE
,
      
CORRCTN
,
      
SIMPLIFD
,
      
Electronic
,
      
ECTRX
,
      
BKTSLSAM
,
      
BKTFRTAM
,
      
BKTMSCAM
,
      
BackoutTradeDisc
,
      
Factoring
,
      
DIRECTDEBIT
,
      
ADRSCODE
,
      
EFTFLAG
,
      
DEX_ROW_TS
FROM dbo.RM30101
WHERE DOCNUMBR IN ( ‘XXXX’ )
–DELETE FROM dbo.RM30101
–WHERE DOCNUMBR IN ( ‘XXXX’ );

— Move RM Tax Work File , RM Tax History
RM10601 > RM30601
INSERT INTO dbo.RM10601
(
   
BACHNUMB
,
   
RMDTYPAL
,
   
DOCNUMBR
,
   
CUSTNMBR
,
   
TAXDTLID
,
   
TRXSORCE
,
   
ACTINDX
,
   
BKOUTTAX
,
   
TAXAMNT
,
   
ORTAXAMT
,
   
STAXAMNT
,
   
ORSLSTAX
,
   
FRTTXAMT
,
   
ORFRTTAX
,
   
MSCTXAMT
,
   
ORMSCTAX
,
   
TAXDTSLS
,
   
ORTOTSLS
,
   
TDTTXSLS
,
   
ORTXSLS
,
   
POSTED
,
   
SEQNUMBR
,
   
CURRNIDX
   — TXDTLPCTAMT
)
SELECT BACHNUMB,
      
RMDTYPAL
,
      
DOCNUMBR
,
      
CUSTNMBR
,
      
TAXDTLID
,
      
TRXSORCE
,
      
ACTINDX
,
      
0
,
      
TAXAMNT
,
      
ORTAXAMT
,
      
STAXAMNT
,
      
ORSLSTAX
,
      
FRTTXAMT
,
      
ORFRTTAX
,
      
MSCTXAMT
,
      
ORMSCTAX
,
      
TAXDTSLS
,
      
ORTOTSLS
,
      
TDTTXSLS
,
      
ORTXSLS
,
      
POSTED
,
      
SEQNUMBR
,
      
CURRNIDX
      
–TXDTLPCTAMT
FROM RM30601
WHERE DOCNUMBR IN ( ‘XXXX’ );
–DELETE FROM RM30601
–WHERE DOCNUMBR IN ( ‘XXXX’ );
— Move RM Distribution Details , RM Tax
History RM10601 > RM30601
INSERT INTO dbo.RM10101
(
   
TRXSORCE
,
   
POSTED
,
   
POSTEDDT
,
   
PSTGSTUS
,
   
CHANGED
,
   
DOCNUMBR
,
   
DCSTATUS
,
   
DISTTYPE
,
   
RMDTYPAL
,
   
SEQNUMBR
,
   
CUSTNMBR
,
   
DSTINDX
,
   
DEBITAMT
,
   
CRDTAMNT
,
   
PROJCTID
,
   
USERID
,
   
CATEGUSD
,
   
CURNCYID
,
   
CURRNIDX
,
   
ORCRDAMT
,
   
ORDBTAMT
,
   
DistRef
)
SELECT TRXSORCE,
      
1
,
      
POSTEDDT
,
      
1
,
      
0
,
      
DOCNUMBR
,
      
1
,
      
DISTTYPE
,
      
RMDTYPAL
,
      
SEQNUMBR
,
      
CUSTNMBR
,
      
DSTINDX
,
      
DEBITAMT
,
      
CRDTAMNT
,
      
PROJCTID
,
      
USERID
,
      
CATEGUSD
,
      
CURNCYID
,
      
CURRNIDX
,
      
ORCRDAMT
,
      
ORDBTAMT
,
      
DistRef
FROM dbo.RM30301
WHERE DOCNUMBR IN ( ‘XXXX’ );
–DELETE FROM dbo.RM30301
–WHERE DOCNUMBR IN ( ‘XXXX’ );




Best Regards, 
Mahmoud M. AlSaadi

Optimizing Transportation Business with Microsoft Dynamics GP

Smart deliveries through connected operations, with flexibility and scalability in the day-to-day operations, while keeping pace with current trends is the norm of the present-day transportation sector. Microsoft Dynamics GP is the best tool for a business owner in the transportation sector. Offering the required visibility across your distribution, customer service, sales, and marketing systems, Microsoft Dynamics GP lets you innovate products and processes to meet the varying needs of the market and your customers. You can not only simplify production management, but also accelerate product introductions, and offer flexibility in delivery schedules and time.

[icon name=”circle” class=”” unprefixed_class=””] Optimized Transportation – Logistics

The Transportation Management module in Microsoft Dynamics GP for Operations lets you manage your company’s transportation, and lets you identify the vendor and routing solutions for inbound and outbound orders. It also helps you to:

Efficiently Plan Inbound and Outbound Transportation: Pricing and market pressures are part of the game, making it essential to seek ways to drive down the operating costs through the process of improvements wherever, and however, possible. One way to drive down costs is by improving on inbound and outbound transportation. While ordering items from a vendor or while shipping products to customers, we can efficiently optimize the shipping process based on due date, cost, and equipment capacity. Get an end-to-end visibility from order to payment and delivery, achieve substantial lead time reduction, and improve the overall manufacturing process.

Ensure On-time Delivery: While accepting/dispatching deliveries to and from vendors or customers, you generally have multiple delivery options for a shipment. These are often based on certain business restrictions such as delivery time, transportation costs, or driving distance. No matter what route or means we choose, ensuring on-time delivery with minimal costs becomes a requirement. Microsoft Dynamics GP analyzes all factors that have a direct or indirect bearing on delivery time, and choose the fastest route.

Enable Accurate Shipment: One of the main purposes of any transportation management system is to ensure perfect order fulfillment. By defining the origin of a sales order based on customer demands and stock levels at company locations, Microsoft Dynamics GP carefully evaluates the various shipments and enables us to achieve accurate shipments, every single time. If you’re wondering whether it is worth moving inventory from one factory location to another before goods are shipped to the destination, or if it makes more sense to ship to the destination, from say the closest factory – Microsoft Dynamics GP has all the answers.

Identify and Choose the Most Profitable Carriers: Microsoft Dynamics GP is built with cutting-edge business intelligence, allowing us to plug into large, existing networks of suppliers and carriers, and save time and costs. By sifting through thousands of suppliers and vendors, it identifies the most profitable and suitable ones. Get a unified view of all the existing carriers, see how they rank against one another as well as against benchmarks and analyze their performance over time – gaining a true understanding of if the carrier network you’re planning to choose is performing at optimum levels.

[icon name=”circle” class=”” unprefixed_class=””] Optimized Transportation – Inventory

Efficient management of inventory requires us to have to-the-minute information about every movement. As we determine how and when inventory moves, and in what quantity, we can order just the right quantity of goods. Microsoft Dynamics GP for Operations helps keep a budget on track and enables you to efficiently manage operating capital. It also helps to:

Enjoy Real-time Visibility: Transportation Management goes beyond transportation concerns and provides real-time visibility into the entire order and delivery process to everyone who needs it: from procurement, warehousing, and production scheduling managers to supply chain and transportation staff. This role-based visibility helps you cut costs and improve efficiency across the supply chain, while simultaneously making better buying decisions. Such visibility also helps you identify and take corrective action on process gaps that cause variability in the supply chain, giving you unprecedented control over orders in transit.

Improve Inventory Levels: Improving supply chain processes often results in considerable reduction of inventory. With Microsoft Dynamics GP, you can know exactly when an order will ship, how much has been shipped, and when it will arrive – all in real-time. End-to-end visibility on the status of orders and shipments helps you maintain the optimum level of inventory, and helps to plan and respond to deliveries more effectively.

Ensure Accurate Replenishment: Replenishing your inventory is one of the most crucial tasks in transportation management. With Microsoft Dynamics GP for Operations, you can set up a replenishment process based on the minimum/maximum replenishment strategy – depending on when inventory falls below the minimum level, the location will be automatically replenished. We could also enable replenishment based on demand – when demand replenishment is triggered, it will first try to find existing demand replenishment jobs. It will then deduct the demanded quantity from the existing demand replenishment fulfilling these criteria. If the quantities on an existing demand replenishment work item are not enough to fulfill the new demand, a new demand replenishment work order will be created.

[icon name=”circle” class=”” unprefixed_class=””] Boost Customer Satisfaction

When we use the transportation management module of Microsoft Dynamics GP, we will be able to see a huge difference in customer perception. By efficiently planning your transportation, ensuring on-time delivery, optimizing costs, and ensuring accurate shipment, we are not only improving your business process efficiency but also ensuring better customer satisfaction. And having visibility into your supply chain, improving inventory levels, and ensuring accurate replenishment only adds to the satisfaction. Our experience and expertise with hardworking tech team at SIROCo make Microsoft Dynamics GP work seamless with round the clock support and training. Feel free to contact us for more information and to discuss your needs to move Microsoft Dynamics GP.

Dynamics GP 2018 – Workflow History Reporting

0Workflow reporting is always important, it’s always required to track the workflow history of a specific purchase requisition, AP transaction, General Ledger batch …etc. Despite the fact that this has always been available with through the workflow history inquiry, Dynamics GP 2018 introduces another interesting way to have detailed reporting on all the workflow history details.

Go To Reports > Company > Workflow History.

Workflow History Report
Workflow History Report

There are several report ranges, so that you can print reports based on multiple criteria. That includes any of the following:

[icon name=”circle” class=”” unprefixed_class=””]Workflow Type
[icon name=”circle” class=”” unprefixed_class=””]Workflow Manager
[icon name=”circle” class=”” unprefixed_class=””]Workflow User
[icon name=”circle” class=”” unprefixed_class=””]Completion Date
[icon name=”circle” class=”” unprefixed_class=””]Due Date

In this essence, you may print a workflow history report for all the workflow types for a specific manager or user. This would never be possible with the use of workflow history inquiry, which is associated with only one transaction such as purchase order, requisition … etc.

On the other hand, it is possible to filter by any workflow type. Once the workflow type range is selected from the list, you will have all the available workflow types to choose from as illustrated below:

Workflow History – Types

Here is a screen shot of the workflow history report:

Workflow History Report

Best Regards,

Mahmoud M. AlSaadi

Recent Posts
Archives
Categories
Meta