Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Backorders Issues

(0) ShareShare
ReportReport
Posted on by 5

Hello all,

I am new to the GP forums, I've been using GP for about 2+ years now.

I never got this question solved, maybe I could get it resolved now. 

When I fulfill my orders & transfer the batches.

After, I will print my backorders.. Some of my backorders will have line comments, but when as they print, the line comments do not print with the backorders. 

But, when i go into the BKO #, the line comments are in GP software, but print out on paper. 

Does anyone know how to fix this issue? or is it normal?

It's quite tedious to write every line comment for each material that's backordered.

Thank You,

Kha

Categories:
  • Michael1379 Profile Picture
    Michael1379 5 on at
    RE: Backorders Issues

    OK thats good to know thanks for the update.

    Prepaid Card Status

  • Jeff Grant Profile Picture
    Jeff Grant on at
    RE: Backorders Issues

    Hi Kha,

    Thank you for attaching your report detail, it is appreciated!

    I can see you are using the SOP Blank Return Form in your process, which does have the same tables/build of the SOP Blank History Back order form where the comments have their own section blocks as well as a standardized arrays in place to split up large sections of data (this is done by the specific processing code behind the report).

    As the build is the same but the data is not populating it does tell you the report is working by design in that the code behind the report is not pulling in the comment materials as it was not initially designed to do so.

    As a potential workaround, in the side Toolbox window of Report Writer you can populate the 'Sales Line Comment Work and History' in the drop-down where you will see the available field options to display on the report.

    Select 'Comment Text' and drag and drop it onto a section of the layout (expand the H2-Item section for instance and place under 'Item Description, for instance) and then print the modified report afterward to see if it pulls in any comment detail as a result.

    If it does not then it is not likely the comments will be available for the SOP document you outlined and the manual workaround would need to be used to add comments accordingly.

    Best Regards,

    Jeff

  • khamopipe Profile Picture
    khamopipe 5 on at
    RE: Backorders Issues

    eff, 

    I've gotten this far via attachment picture. 

    I am clueless when you said "(dragging the CMMTTEXT field on the reporting and testing to see if it will pull in as a result)."

    If there's a specific step by step click instructions that you could let me follow, I am more certain I could fix my item comment issues on backorders.

    8741.REPORT-TABLE-RELATIONSHIPS.png

    Again, I appreciate the help you're giving me & more,

    Kha

  • Jeff Grant Profile Picture
    Jeff Grant on at
    RE: Backorders Issues

    Hello kha,

    Thank you for the update, my apologies if my initial reply was vague.

    The gist behind my reply is that your result is most likely 'by design' and the back order comments are not included to populate the reporting in the report that you are referring to in your post by default.

    Note that my testing was for printing the Backorder batch in Sales (prior to posting) in which the backorder comment will show only if set at the 'detail' level (expand each line with the blue arrow next to 'Item Number') per item included on a Backorder document and not from the bottom 'Comment ID' listing of the document (the 'header').

    When I print the Backorder in such fashion the comment placed at the detail level will populate the resulting SOP Blank Back Order document in the description field of each backrodered item (below the main item description).

    However, as I am not certain when you are producing your reporting, if the exact report isn't built from the tables that carry the comment information in the report I tested then 'adding' the comment materials may or may not be possible in the current design.

    Your screenshot is too small to expand for more detail, but what I would next recommend is minimizing the report layout (your screenshot window) in Report Writer where you should see the Report Definition window behind it.

    Select 'Tables' from this window to open the Report Table Relationship window, which outlines all the existing tables that are included in the report by default.

    If either of the tables mentioned prior ('Sales Line Comment Work and History' or 'Sales User-Defined Work History') is listed as one of the tables then your request may be possible with a simple modification (dragging the CMMTTEXT field on the reporting and testing to see if it will pull in as a result).  In such case I can also expand in more detail via this forum posting.

    If neither table is listed then it may be possible to link one of the tables carrying the comment to your report but as this process is quite extensive it is something we would likely need a support case established for in order to get you the detailed instruction you are looking for in order to modify the default reporting in such manner.

    Best Regards,

    Jeff

  • khamopipe Profile Picture
    khamopipe 5 on at
    RE: Backorders Issues

    Not to be an inconvenience, but I hardly understood this at all.

    This is all I could understand:

    If you could, step by step process for me on how to fix this issue?SOP-BLANK-BKO.png

  • Suggested answer
    Jeff Grant Profile Picture
    Jeff Grant on at
    RE: Backorders Issues

    Hello Kha,

    My name is Jeff and I'm a Support Engineer for Dynamics GP, thank you for your post!

    On this end I have tested your issue on the latest Dynamics GP code and found the initial comment should print by design on the SOP Blank Back Order form as long as it is added at the line level (expand Line Item | enter Comment on the Sales item Detail Entry level) and not the Comment section on the header (Transactions | Sales Transaction Entry) of the documents.

    The SQL tables the comment information is stored are SOP10202 (Sales Line Comment Work and History) in the COMMENT_1/CMMTTEXT fields for the details and the SOP10106 (Sales User-Defined Work History) in the COMMENT_1/CMMTTEXT fields for the header.

    What I would recommend in your testing is first printing the report in question out to the screen, then select 'Modify' to open the reporting up in Report Writer.

    Then review the 'Tables' selection for the report in question, are either the SOP10202/SOP10106 tables listed as default items behind the reporting?

    If not then your performance is by design but you may be able to link the tables in question to the tables present on the reporting to print the COMMENT_1/CMMTTEXT values (if still available).

    If the table is already present, try dragging the CMMTTEXT line onto the report layout to see if the simple report modification would allow the field content to show accordingly.

    Best Regards,

    Jeff Grant

    Microsoft Dynamics GP

  • khamopipe Profile Picture
    khamopipe 5 on at
    RE: Backorders Issues

    Joe, 

    Sales Batch Entry > Print : Sales Document Print Options >  Check Backorder > Print

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Backorders Issues

    Hi Kha-

    How are you printing the back orders when you print them all at once?

    Joe

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans