We are using SAP Business One Hana . we may payment voucher and keep in draft . but when we go to payment draft report , we see the same voucher number for many drafts . we would like to get an unique internal id number for each draft we have saved . Could you please let provide me the solution
Having the same voucher number for many draft documents is Standard SAP B1. The reason being is that SAP B1 does not assign a "real number" (unique ID number) until it is changed to a "real document". Why??? Because there could be a huge number of Document Numbers being used up, depending upon how much the function of draft is done at some companies.
But that does not help you much, does it??? I can make a suggestion of how it was done with one Customer.
What one Customer did was to add a UDF on the Marketing Documents "Title" named "DrftNotes" (Alphanumeric, 50 characters, Regular Structure).
When a Sales Person entered a draft, they would put in a standard entry in that field of Initials, Cust Code, and date of YYYY MM DD. Like this: "ZP C0211 2018 12 22". All the Sales Personnel were required to do this, since every Sales Order had to be reviewed.
They then added that field to the Standard SAP B1 Document Draft Report so everyone could see it by using the Form Settings Function on the Document Draft Report. Also helped by sorting by DrftNotes for individuals to find their drafts easily. They also wrote an SQL having a WHERE clause with a LIKE command, where Users could enter their initials. Table was called ODRF, if I remember correctly.
Maybe that helps??? I hope so...
Oh, another thought might be a Formatted Search or Stored Procedure to create that information in the UDF??? Just thinking here, have not seen it, but maybe some ideas to get the wheels turning...