There are about 150 records in the past two days coming up with a blank Docnumbr. The batches are no stuck. there are records in about 8 atches
SELECT TOP (100) PERCENT DOCNUMBR, BACHNUMB, PMNTNMBR AS Expr1, DOCDATE
FROM dbo.PM10300
WHERE (DOCNUMBR = ''
*This post is locked for comments
Use the Print Payables Checks window (Transactions-->Purchasing-->Print Checks) to print those 8 batches. After printed the batches, DOCNUMBR field values will be updated to the tables(PM10300 and PM00400).
Note: Check number value is the DOCNUMBR. Only printed batches have DOCNUMBR values in the table(PM10300 and PM00400)
Let me clarify few points about PM10300 Payment Work.
This table is related to the "Edit Payable Checks" window. When a new payment number is recorded on the screen, a record will be thrown in PM10300 and PM00400.
When you click on "Print Checks", you will find no (Document Number) field in the screen. If you print the checks without changing the (Check Number) field, you will find the (Document Number) field in PM10300 either empty or with the same (Check Number Value). In case you change the check number on the Print Checks window, the new value will be stored in Document Number field in PM10300.
Note:
In PM10300, the payment number is stored in the (PMNTNMBR | Payment Number), the corresponding field in PM00400 is (CNTRLNUM | Control Number).
The bottom line, it is a normal behaviour to have blank document number in PM10300 as it is not the primary key of the PM10300, unique documents in this table have unique Payment Number.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
