Skip to Content
avatar image
Former Member

AP GL JE Posting

Hi,

I need AP invoice posting to different GL Account ,

Interstate Purchase -----------> Interstate GL Account

Local Purchase -----------> Local GL Account

Imported ------------> Export GL Account

Inline image 2

as per the image GL JE Preview . Account is posted to Domestic Purchase. In this place I need GL account above mentioned under criteria

** Items Each may Inter state or Local or Imported

Is It Possible in B1

Regards Akhil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    Mar 23, 2017 at 10:10 AM

    For 8.8 version Advanced GL determination is not available. And for purchase accounting system can you share the Company details screen shot , you can find under company details-->Use Purchase Accounts Posting System

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 23, 2017 at 08:28 AM

    Hi Akhil,

    Your image is not visible and please clarify which GL you are talking about?

    Recon Account Gl or Expense GL??

    Regards

    Eugene

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2017 at 08:44 AM

    ap-invoice-gl-privew.png

    AP Invoice Journal Preview attached

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2017 at 08:46 AM

    Expense GL Account

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 23, 2017 at 09:32 AM

    Hi Akhil T Prasad,

    You enabled purchase posting system. Use advance GL rules to meet your requirement.

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      How can I enable purchase posting system ? Where I find Advanced GL rule?

      Now I am using SAP B1 8.8.1 PL11

  • Mar 23, 2017 at 09:52 AM

    The JE preview resembles purchase accounting system enabled already. You can find advance GL rule setting under GL determination setup window , if you had enabled the -->Enable Advanced G/L Account Determination under company details

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2017 at 09:53 AM

    How can I enable purchase posting system ? Where I find Advanced GL rule?

    Now I am using SAP B1 8.8.1 PL11

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 28, 2017 at 04:02 AM

    use-pur.pngUse Purchase Accounts Posting System already eabled .

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28, 2017 at 08:02 AM

    Hi,

    It is not possible for you to do that in your SAP B1 version.

    You need to upgrade to SAP B1 9.0 or higher and use advanced G/L account determination.

    Since you didn't tell us how to distinguish that the item can be Interstate Purchase, Local Purchase, Or Imported. Please consider that advanced G/L account determination only provides the following criteria (SAP B1 9.2) :

    • Item Group
    • Item Code
    • Warehouse Code
    • Business Partner Group
    • Ship-to Country
    • Ship-to State

    Note :

    • you cannot define additional determination criteria
    • you can choose more than one criteria to be combined

    Hope this helps :)

    Regards,

    Rizki

    Add comment
    10|10000 characters needed characters exceeded