Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jeff Roe]

Is there an easy way to link posted Vendor invoices for DROP Ship parts to the associated posted Customer Invoice in AR.  In reconciling the GL account for May, we are showing a balance where we should not.  We need to identify the AP transactions that do not have a coordinating Invoice in AR.
What common field can we map against to pull this data.

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————

[Matthew Arp]

Are you using the SOP-POP link? If so you should be able to associate the PO back to the original order (SOP60100)

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Thaddeus Suter]

Jeff,

As you have found out, one of the challenges when using SOP Drop Ship functionality is that when the Vendor Invoice is matched in POP/AP, the user may not see the message about the Drop Ship SOP Order and it gets left and not transferred to an SOP/RM Invoice and posted.

Two bad things occur: The Drop Ship Clearing account does not clear and is left with a debit balance (the Accountants get excited) and the Customer does not get invoiced (no cash gets collected).

This is where Smartlist is your friend.

Under Sales – Sales Line Items make a Favorite called “Drop ShipMents”
Set two filters: DROP-SHIP = 1 and Document Status = Unposted.

Then add the Column for Purchasing Status and sort for “Partially or Fully Received”. If Purchasing Status = None, Needs Purchase or Purchased, this means the PO has not been done yet or not yet Invoiced. Those SOs are OK as for as Transferring to an Invoice, they are not ready.

Partially or Fully Received status will capture all SOP Order Lines which are Drop Ship and the Vendor Invoice has been Received/Matched by AP but the SO has not been transferred to a SOP Invoice and posted. These are your problem SOs and need to be dealt with.

The balance of extended costs by Status in this Smartlist can also be a good basis for the debit balance in the Drop Ship Clearing account.

When all AP/POP Invoiced Drop Ship Orders have also been RM/SOP Invoiced and Posted, the account will clear and this DropShip Smartlist will be empty for “Partially or Fully Received” lines

——————————
Thaddeus Suter
Retus, Inc
Helotes TX
——————————
——————————————-