Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error in reprinting/po...
Finance | Project Operations, Human Resources, ...
Unanswered

Error in reprinting/posting BI invoices

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

My client has a number of Flexible Billing invoices which printed, but do not post to AR. Looking at the PJINVHDR records, I see that the invoice number has been assigned, but the batch number and fiscal period have not. I tried running the Invoice and Adjustment posting (thinking that something interrupted the process,) but that did nothing other than leave a BI/INVOICE-REGISTER record in the control parameter files.

I  tried to reprint several of the invoices and received this error for all of them: "0118: Report Control record for invoice/attachment ' ' not found." 

Any ideas where to look to resolve this error/issue?

Thanks! 

Stuart Nottingham

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in reprinting/posting BI invoices

    After comparing the DB Calls Event log posted earlier with one from another system (plus a SQL trace log,) I determined that one of the invoices found in PJINVHDR had no corresponding records in PJINVDET. I changed the inv_status from PR to PO and was able to post the balance of the invoices.

    Thanks, everyone, for your help!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in reprinting/posting BI invoices

    Just tried that, Jana, with no change. I did find some old records there and deleted them before trying to run the posting process.

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Error in reprinting/posting BI invoices

    The last thing it looks at is pjglsort. (PJGLSORT_SPK2) Maybe delete from that table?

    Jana MacDonald

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in reprinting/posting BI invoices

    Jana, I tried Standard mode and it made no difference. I verified that BI420 was not hung up in RPTCONTROL. I turned on Database Calls for the event log and have posted it below (did not have this on prior.)

    Computer:DYNAMICSRDP-Tcp#0

    sqlcursor(cursor=81,name=SessionLimitCheck)

    Sql(cursor=81,"Select COUNT ( DISTINCT InternetAddress ) From Access where ScrnNbr LIKE '%%' AND ScrnNbr <> 'MENU' AND ScrnNbr NOT LIKE '86%' AND ScrnNbr NOT LIKE '81%' AND ScrnNbr NOT LIKE 'RDT%' AND UserId <> 'MasterAccess' AND InternetAddress <> 'DYNAMICSRDP-Tcp#0' AND ScrnNbr NOT LIKE 'TE%%%' AND ScrnNbr NOT LIKE 'TM%%%' AND ScrnNbr NOT LIKE 'PP%%%'")

    sFetch(cursor=81)

    Sql(cursor=81,"Select COUNT ( DISTINCT InternetAddress ) From Access where ( ScrnNbr = '96010' OR ScrnNbr = '40400' ) AND InternetAddress <> '%%'")

    sFetch(cursor=81)

    sqlcursor(cursor=81,name=AccessLockCursor)

    TranBegin

    TranBegin (SysDb)

    sFetch(cursor=81)=EOF

    sInsert(cursor=81,)

    TranEnd

    TranEnd (SysDb)

    sqlcursor(cursor=41,name=SwimAttachConfigCsr)

    Sql(cursor=41,"SELECT * FROM [AttachConfig] WHERE [AttachmentType] = 'S' AND ([ScreenNumber] LIKE 'BIREG__' OR ([ScreenNumber] = 'DEFAULT' AND [TableName] = 'DEFAULT'))")

    sFetch(cursor=41)=EOF

    sqlcursor(cursor=81,name=81)

    sFetch(cursor=81)

    Sql(cursor=30,"Select ArAcct, ArSub, TranDescDflt from arsetup")

    sFetch(cursor=30)

    Sql(cursor=30,"pjcontrl_spk0 'PA', 'DEFAULT-TASK' ")

    sFetch(cursor=30)

    Sql(cursor=30,"pjcontrl_spk0 'PA', 'BTD' ")

    sFetch(cursor=30)

    Sql(cursor=30,"pjcontrl_spk0 'PA', 'CONTRACT-VALUE' ")

    sFetch(cursor=30)

    Sql(cursor=30,"pjcontrl_spk0 'BI', 'SETUP' ")

    sFetch(cursor=30)

    Sql(cursor=1,"pjcontrl_spk0 'BI', 'SETUP' ")

    sFetch(cursor=1)

    sqlcursor(cursor=41,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

    Sql(cursor=41,"glsetup_spk0")

    getnewdbproc, dbname = MITEC, retcode = 0

    sFetch(cursor=41)

    sqlcursor(cursor=42,name=c_MCSetup_1)

    Sql(cursor=42,"Select MCActivated from MCSetup ")

    sFetch(cursor=42)

    Sql(cursor=30,"select validcombosrequired from FLEXDEF  where  FieldClassName = 'SUBACCOUNT'")

    sFetch(cursor=30)

    Sql(cursor=30,"select ValidateAcctSub, ValidateAtPosting from GLSETUP")

    sFetch(cursor=30)

    Sql(cursor=30,"pjtext_spk0 '0608' ")

    sFetch(cursor=30)

    Sql(cursor=30,"pjcontrl_spk0 'PA', 'FOREIGN-CURRENCY-BILLING' ")

    sFetch(cursor=30)

    Sql(cursor=30,"pjcontrl_spk0 'BI', 'INVOICE-LOGGING' ")

    sFetch(cursor=30)=EOF

    sFetch(cursor=1)=EOF

    TranBegin

    sqlcursor(cursor=43,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

    Sql(cursor=43,"select convert(smalldatetime, getdate())")

    sFetch(cursor=43)

    sqlcursor(cursor=43,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

    Sql(cursor=43,"select convert(smalldatetime, getdate())")

    sFetch(cursor=43)

    sInsert(cursor=1, pjcontrl: INVOICE-REGISTER,INVOICE REGISTER user=SYSADMIN,Multi-currency Billing Flag,01082021,BIREG,SYSADMIN,01082021,BIREG,SYSADMIN,BI)

    TranEnd

    Sql(cursor=30,"pjcontrl_spk0 'BI', 'POST-BY-TASK' ")

    sFetch(cursor=30)=EOF

    Sql(cursor=30,"pjtext_spk0 '0665' ")

    sFetch(cursor=30)

    System Message 6124: Process started: Fri Jan 08 03:37 P.M.

    Sql(cursor=30,"pjtext_spk0 '0631' ")

    sFetch(cursor=30)

    Sql(cursor=4,"PJGLSORT_Init")

    sFetch(cursor=4)=EOF

    Sql(cursor=10,"ARDOC_Init")

    sFetch(cursor=10)=EOF

    Sql(cursor=9,"ARTRAN_Init")

    sFetch(cursor=9)=EOF

    Sql(cursor=11,"GLTRAN_Init")

    sFetch(cursor=11)=EOF

    Sql(cursor=25,"PJTRAN_SPK1")

    sFetch(cursor=25)=EOF

    Sql(cursor=26,"PJTRANEX_SPK1")

    sFetch(cursor=26)=EOF

    Sql(cursor=27,"pjtranwk_init")

    sFetch(cursor=27)=EOF

    Sql(cursor=39,"pjinvdet_spk9")

    sFetch(cursor=39)=EOF

    Sql(cursor=2,"pjdocnum_spk0 '4' ")

    sFetch(cursor=2)

    Sql(cursor=15,"batch_spk0 '106149', 'BI' ")

    sFetch(cursor=15)

    TranBegin

    Sql(cursor=15,"BATCH_uSTATUS '106149', 'BI', 'U' ")

    schk(pmsg={call BATCH_uSTATUS( '106149',,poption=SqlState = 01000 NativeError = 16954 Er,cursor=15,err=16954)

    TranEnd

    TranBegin

    Sql(cursor=2,"pjdocnum_spk0 '4' ")

    LockRow(cursor=2) = 0

    sFetch(cursor=2)

    sUpdate(cursor=2,pjdocnum(id= '4')lastused_4=106150)

    Sql(cursor=15,"batch_spk0 '106150', 'BI' ")

    sFetch(cursor=15)=EOF

    sqlcursor(cursor=43,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

    Sql(cursor=43,"select convert(smalldatetime, getdate())")

    sFetch(cursor=43)

    sqlcursor(cursor=43,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

    Sql(cursor=43,"select convert(smalldatetime, getdate())")

    sFetch(cursor=43)

    sInsert(cursor=15, batch: ,0,0,A,,,USD,106150,N,.00000000,0,001MIT,01082021,BIREG,SYSADMIN,.00000000,.00000000,.00000000,.00000000,.00000000,.00000000,,USD,M,.00000000,,0,,,.00000000,,.00000000,BIREG,D,BI,ACTUAL,01082021,BIREG,SYSADMIN,BI,0,0,,,,202012,202012,1,,,.00000000,.00000000,.00000000,.00000000,,,0,0,,,H,,,,.00000000,2.00000000,,,,)

    TranEnd

    Sql(cursor=33,"pjinvhdr_spk5 '001MIT', '06/06/2079', '%', '%', '202012', 'USD' ")

    sFetch(cursor=33)

    TranBegin

    Sql(cursor=30,"pjtext_spk0 '0665' ")

    sFetch(cursor=30)

    Sql(cursor=5,"pjinvhdr_spk0 '0000083646' ")

    LockRow(cursor=5) = 0

    sFetch(cursor=5)

    Sql(cursor=30,"pjtext_spk0 '0546' ")

    sFetch(cursor=30)

    Sql(cursor=30,"pjpent_spk0 '281351', '' ")

    sFetch(cursor=30)=EOF

    Sql(cursor=30,"pjpent_spk1 '281351', '%' ")

    sFetch(cursor=30)

    Sql(cursor=12,"customer_spk0 '0111502412' ")

    LockRow(cursor=12) = 0

    sFetch(cursor=12)

    sqlcursor(cursor=43,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

    Sql(cursor=43,"SalesPer_slsPerID 'MITEC' ")

    sFetch(cursor=43)

    Sql(cursor=4,"delete from pjglsort")

    Sql(cursor=4,"PJGLSORT_Init")

    sFetch(cursor=4)=EOF

    Sql(cursor=31,"PJINVDET_SPK6 '0000083646' ")

    sFetch(cursor=31)=EOF

    Sql(cursor=3,"pjbill_spk0 '281351' ")

    LockRow(cursor=3) = 0

    sFetch(cursor=3)

    Sql(cursor=30,"pjcode_spk0 'BRUL', 'FP1' ")

    sFetch(cursor=30)

    Sql(cursor=4,"PJGLSORT_SPK2")

    sFetch(cursor=4)=EOF

    sqlcursor(cursor=44,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

    Sql(cursor=44,"select convert(smalldatetime, getdate())")

    sFetch(cursor=44)

    sqlcursor(cursor=44,name=DefaultCreated)

    Auto allocating cursor: DefaultCreated

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in reprinting/posting BI invoices

    No event log other than the process starts, Jana.

    No message on the screen, just an immediate close. I haven't checked for the format in rptcontrol, but I will and update.

    It does create $0.00 batches for posting in GL, but there are no transactions associated with those batches.

    Have not tried standard mode as the screen is not customized. Again, I will try it and report back.

    Thanks for responding!

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Error in reprinting/posting BI invoices

    Dear Stuart,

    Do you get an event log?

    Do you get any message in the screen? At posting I believe the invoice register prints.

    have you run the rptcontrol or checked it for that format?

    have you tried to run in standard mode?

    Best Regards,

    Jana MacDonald

    MSFT Support

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in reprinting/posting BI invoices

    Hopefully to add some clarity to the issue:

    1. All the invoices are AIA invoices. All print with no issue.

    2. Post printing, when we attempt to post to AR  using the Invoice and Adjustment Posting, the screen immediately closes down without posting to the GL or to AR.

    3. The BI/INVOICE-REGISTER control parameter is left in the PJControl table and must be deleted.

    This is not an invoice printing issue, but a posting issue. I truly appreciate any help on this, as I'm quickly losing the little bit of hair I have left.

    Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in reprinting/posting BI invoices

    I find that I able to print the invoices in construction billing. However, the error in posting remains an issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans