You’re offline. This is a read only version of the page.
I am hoping someone can quickly expalin a few of the tables/values in the Reservation table. Particualrly, I am looking for:
What is the difference in Reservation Status between Reservation, Prospect and Surplus? (are there others I haven't seen?)
What are the various Source SubType referring to (I know that the Source Type refers to the various transactions type (item journal, item line entry, sales line, etc)
What is the Source Batch Name (in my current file and testing, it has usually been blank and not sure if/when it is needed for an import)
Thanks,
Kevin
Yes, it was from I guess 6 different sources. I put it long time a go together for myself (and added some personal notes to it) since we use Reservation Table a lot and I needed to understand it better since we had/have issues with it.
Hi
For table relationship see this : dynamicsdocs.com/.../reservation-entry
Reservation Status:
Reservation: This is a reservation. Usually, the user has reserved this item for the order
Tracking: The program has allocated the supply for this demand. The system only tracks if the Tracking Policy field on the item card is set to Tracking Only or Tracking & Action Msg., or during planning in the planning worksheet.
Surplus: Surplus occurs in connection with tracking, for example, if the supply is not allocated to any demand, or the demand is not allocated to any supply.
Prospect: Used for non-order network entities, e.g. item journal line, to carry item tracking.
Source Subtype Field
Indicates which source subtype the reservation entry is related to. If the entry is related to a purchase or sales line, the field is copied from the Document Type field on the line. If it is related to a journal line, the field is copied from the Entry Type field on the journal line.
"Source type" is the ID of the related table. so if it says "37", then it's "Sales Line".
"Source Subtype" is a further identification of the related table. In case of "Source type" = "37", then "source subtype" is the field "Document type" of table 37. In this case it could be Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order. For purchase table it could be different subtype. If you use Journal Line then it is depends on Entry Type on the journal line.
Source Batch Name Field
Contains the journal batch name if the item comes from a journal line. The program copies the source batch name from the Batch Name field on the journal line. You need to add something to reservation table through journal to populate this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
