Open Forum

Expand all | Collapse all

SOP Invoice Dist. Fails to Default

  • 1.  SOP Invoice Dist. Fails to Default

    Posted 13 days ago
    Here's a bizarre issue. When entering an invoice thru Sales Transaction Entry, we're seeing an issue defaulting the RECV distribution for multi-line transactions. The customer has default accounts set. The items have default accounts set. It doesn't matter which items we use, the first line will pick up the default for RECV, then the second line item will not. Again, this is regardless of item number selection, so even if I swap item numbers between lines, the first one entered always works, and the second doesn't. This doesn't happen in our test company which was last refreshed from production in October. I've compared everything I can think of to find what has changed in prod that is causing this behavior. I've looked at item setup, item class setup, customer setup, customer class setup, sales order processing setup, document type setup, company level posting setup defaults and everything appears to match between test and prod. This all happens using the SA account as well, so permission issues are out. When it happens in prod, using the Default button on the Distributions window will fix it, which is even stranger. The items I'm using should use same RECV account and the Default button recognizes this, but for some reason when entering it doesn't do it automatically. The 2 items are of type "Services".  Thoughts?



    ------------------------------
    J.J. Lucarelli
    Sr. Business Apps Developer
    Telular Corporation
    Chicago IL
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: SOP Invoice Dist. Fails to Default

    Posted 13 days ago
    I suggest saving the document in a batch and printing out an edit list.  It will give your more information on what's missing, and help you narrow it down.

    ------------------------------
    Arthur Stewart
    Lutz FL
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: SOP Invoice Dist. Fails to Default

    Posted 12 days ago
    Thank you for the suggestion.  Unfortunately, it didn't give me any more of a clue.  As you can see from the 2 images I've attached, it isn't related to the item setup.  I created 2 invoices to demonstrate, both using the same 2 items just entered in a different order.  The first line always picks up the AR account as expected, the second does not.  They should pick up and combine into the same account and they will if I explicitly press the Default button on the Distributions window.  I can't figure out why they don't automatically during entry.

    ------------------------------
    Jennifer Lucarelli
    Business Apps Developer
    Telular Corporation
    Chicago IL
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: SOP Invoice Dist. Fails to Default

    Posted 12 days ago
    Dumb question, but have your tried  transactions with only one of the items each?  I know it seems like the symptom is the second item always has a missing GL account, but I don't know of any logical reason for this behavior.  If you enter two transactions with each item on them by themselves, you should see very quickly if it's a setup problem or not.  If you get the same error on one of the single-item transactions, you can take a look at that one alone.

    As noted in this link, typically this sort of error is a module, customer or item GL setup issue.

    https://support.microsoft.com/en-us/help/2478324/error-message-no-account-has-been-specified-for-one-or-more-distributi




    ------------------------------
    Arthur Stewart
    Lutz FL
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: SOP Invoice Dist. Fails to Default

    Posted 6 days ago
    Everything defaults fine when I only enter 1 item.  We do not have any customizations.  The customer has AR account default set.  We do not have AR account setup in the Setup --> Posting Accounts for AR because it varies by customer.  This is also true in the test company where everything is working fine.  I know it sounds crazy, but this truly the behavior I'm seeing.

    ------------------------------
    Jennifer Lucarelli
    Business Apps Developer
    Telular Corporation
    Chicago IL
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: SOP Invoice Dist. Fails to Default

    Posted 4 days ago
    If it were a setup issue, I'd expect the error when one or the other of the two items was entered by itself.  You describe the error as happening only when the two items are on the same invoice.  Have you tried using other items just to make sure the error pattern stays the same?  Unfortunately I don't have any other suggestions, given you have no customizations.  Do you have any other GP companies that you can test?  For instance, if you install TWO (the GP test company) I'd be interested to see if the error occurs for an invoice with 2 items in that instance.

    Very bizarre.

    ------------------------------
    Arthur Stewart
    Lutz FL
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: SOP Invoice Dist. Fails to Default

    GPUG ALL STAR
    Posted 12 days ago
    Hi @Jennifer Lucarelli

    What do the options in this window say?  Sales>Setup>Sales Order Processing



    Also, do you have a DEFAULT AR Account setup in Administration>Setup>Company>Posting Accounts?​


    One further question, in the title area of the Sales Invoice Window is there a dot or a period?  It's possible you have some Customization that is affecting that window in that company.

    ------------------------------

    ------------------------------

    Conference-GPUG_200x200


  • 8.  RE: SOP Invoice Dist. Fails to Default

    Posted 6 days ago
    We do not have any customizations.  The SOP Setup window is set to pick up Posting Accounts From Item.  This is true in the test company too.  The customer has AR account default set.  We do not have AR account setup in the Setup --> Posting Accounts for AR because it varies by customer.  This is also true in the test company where everything is working fine.  I know it sounds crazy, but this truly is the behavior I'm seeing.

    ------------------------------
    Jennifer Lucarelli
    Business Apps Developer
    Telular Corporation
    Chicago IL
    ------------------------------

    Conference-GPUG_200x200


  • 9.  RE: SOP Invoice Dist. Fails to Default

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Jennifer, Also see if you have any 3rd parties such as eOne Flexicoder that would affect the distributions.  The main reason I ask is because Inventory Items would have no affect on the RECV distributions.  This will normally pull from the customer or the posting default and an invoice would typically only have one RECV distribution.

    ------------------------------
    Andrew Kennedy
    Principal Consultant
    Velosio
    Seven Hills OH
    ------------------------------

    Conference-GPUG_200x200


  • 10.  RE: SOP Invoice Dist. Fails to Default

    Posted 6 days ago
    Everything defaults fine when I only enter 1 item per transaction.  There is something about the second line (regardless of item number).  We do not have any customizations.  The customer has AR account default set.  We do not have AR account setup in the Setup --> Posting Accounts for AR because it varies by customer.  This is also true in the test company where everything is working fine.  I know it sounds crazy, but this truly is the behavior I'm seeing.

    ------------------------------
    Jennifer Lucarelli
    Business Apps Developer
    Telular Corporation
    Chicago IL
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role