web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Error in reprinting/posting BI invoices

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    on at

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

  • Community Member Profile Picture
    on at

    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!

  • CFROTON Profile Picture
    4,710 on at

    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
    on at

    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!

  • Community Member Profile Picture
    on at

    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

  • CFROTON Profile Picture
    4,710 on at

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

    Jana MacDonald

  • Community Member Profile Picture
    on at

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

  • Community Member Profile Picture
    on at

    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!!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans