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

[Jeff Roe]

I have a need to capture some misc. information in the SOP header.

I see the dstbtch1 and dstbtch2 field but they have nothing in them.

If there is a value, does it trigger an action in GP?
What would it normally have in a typical environment?
What is it’s primary purpose/function?

Thanks

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

[Amy Brown]

Are you looking at a sql table or where are you looking?  

If you are using Sales Order Processing in Setup there is a link to a whole set of User Defined Fields you can use.  There are 3 List options, Date Fields & several Text Fields.  When you to enter an invoice under Sales Transaction Entry click on the Go To in the top tool bar and it will link you to these fields.

——————————
Amy Brown
Consultant
S2 Technology
Boise ID
——————————
——————————————-

[Gregory DeBacker]

Jeff,

We rarely have anything populated in those fields.  In the cases we do, it is “BK” 

If you are looking for fields from your user defined fields that appear on the sales order header, look in the sop10106 table.

——————————
Gregory DeBacker
Regal Lager Inc.
——————————
——————————————-

[Thaddeus Suter]

Those two fields DSTBTCH1 and DSTBTCH2 go with the SOP Setup for Document ID Transfers.

Also in the SOP Header SOP10100 are the Doc ID fields used on the transfer.
They are USDOCID1 and USDOCID2.

So when you transfer an Order to an Invoice, the field USDOCID2 specifies the Invoice Type and the DSTBTCH2 specifies which Batch the new Invoice just transfered will end up in.

The USDOCID1 and DSTBTCH1 specify the Backorder Type and Batch forn and Order transfer to Backorder.

This is a secret function in SOP for advanced users and not widely documented for managing destination batches when transferring  SOP documents. Populate the fields by VBA or SQL trigger based on your process.

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

[Thaddeus Suter]

And I should have said whatever you put in those fields, the SOP Batch will get auto-created on transfer if it does not exist.
So maybe not the best place to store user def stuff

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