Print Invoice Without SOP50200?

(0) Share

Report

Posted on by Community Member

I am trying to consolidate the invoices we have into one stored procedure so that comments for the invoice can be modified on the SQL side instead of opening up the SSRS report. A former contractor created a version for every possible desire. A version for Open Returns, Posted Returns, Open Invoices, Posted Invoices, etc.... Now there are close to a dozen different versions out there in the Forms Printer folder and elsewhere in SSRS, all with in-line scripting. So one change turns into a dozen changes. I understand that the SOP50200 is a temp table for printing invoices and other documents. I am wondering if I can bypass this table. All of the data that is in the SOP50200 table is in either the SOP10100/10200 or the SOP30200/30300 table. So what is the SOP50200 table needed for? Can I bypass the SOP50200 when pulling data to print an invoice?

Thanks

Adam

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Print Invoice Without SOP50200?

I am quoting Sanjay Kumar for this specific case, since he's already provided comprehensive details for this specific inquiry.

"

As the technical name SOP_Document_HDR_TEMP name indicates, SOP50200 is a temporary table.

This table gets populated when any SOP documents is created.

When the print routines are called from GP, records are removed after printing.

If forms printers is used, dex.ini setting ASIFPCLEANUP=TRUE causes the print routine to clean up the table after printing.

"

>> Reference: Dynamics GP SOP50200 table info

So the normal behavior is to have this table populated for printing purposes and removed after the printing.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Print Invoice Without SOP50200?

I get all that and I think I have read that exact quote somewhere. When the process kicks off, it assigns a user ID and a Seq#, which are only needed to tie to the record in the SOP50200 table. The rest of the data comes from the normal SOP tables. If I want to do a print, or a reprint, or just standardize everything with a sproc, I can't use that UserID or Seq# because they are only found withing the SOP50200 table, which means I have to use the GP printing process.

What I am trying to understand is, why can't I go straight to the SOP tables to get the data? That's what is populating the 50200 table. Is there something that is triggered when the SOP50200 table is used? If not, then why not bypass it. I can easily create an invoice without it.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Print Invoice Without SOP50200?

Allow me to get one specific point cleared before digging further. By creating an invoice, quoting you "If not, then why not bypass it. I can easily create an invoice without it. ", do you mean printing the out of the box standard report for invoice ? Or you have another custom SSRS report which retrieves data from SOP tables including SOP5200 ?

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Print Invoice Without SOP50200?

The current versions include forms printer and non-forms printer. Some use SOP50200 and others do not. The ones that use the SOP50200 are the ones where the user prints them directly from the GP interface. The others are printed directly from the SSRS. What I want to do is come up with one stored proc that can run all of them and get rid of the in-line scripting in the RDLs that power the data sets.

I can say that ALL of the invoices are running through SSRS.

Was this reply helpful? Yes No
Verified answer

Victoria Yudin 22,768 on at

Like (0)

Report

RE: Print Invoice Without SOP50200?

If you're using Accountable's Forms Printer product, which I think you mentioned in your original post, you CANNOT bypass the SOP50200 table, as I believe their product requires that. To be 100% certain, you would need to check their documentation or ask their support. If you're printing sales documents without any add-on (for example, directly in SSRS), you can bypass the SOP50200 table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Print Invoice Without SOP50200?

Thanks. I'll double check with the client and make sure I know where every invoice version is coming from.

Was this reply helpful? Yes No