Account Code effect reports?

Discussion in 'Optigold ISP' started by ColinR, Sep 9, 2005.

0
  1. #1
    Shawn,

    In product setup their is the accounting code field. Noticed generally when you click in their it displays in a list format other accounting codes already being used so you could select one from a list.

    Have one product I've setup that its accounting code is not in the list, however when I export out that product along with accounting codes it is their in my file.

    When running reports on the GUI and I want for instance "Product Sales report" summarized by "accounting code" for a certain "Account Class" it displays data in the report from other Account Class's.

    Q1) Could this be related to the Accounting code not being displayed in the list? Basically I'm wondering where the report pulls the accounting code info from. IE product setup or from that list displayed on screen?

    It seems that the products appearing on report in error also are those that do not display in my list in the account code field under edit products.

    Just trying to identify the reporting issue as it appears to be broken now. Exporting of data is fine its just the GUI report is my issue alnog with not being displayed in product setup list.

    Thanks,
     
    ColinR, Sep 9, 2005 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Is it not displaying in the drop-down list under Edit Products or within the Run Reports section?
     
    digitalpoint, Sep 9, 2005 IP
  3. ColinR

    ColinR Guest

    Messages:
    454
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #3
    correct it is not displaying
     
    ColinR, Sep 9, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    I was asking which location you are talking about. :)
     
    digitalpoint, Sep 9, 2005 IP
  5. ColinR

    ColinR Guest

    Messages:
    454
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #5
    heheh fair enough..it does not display in the list in product > Account code.
     
    ColinR, Sep 9, 2005 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    I'm not sure if you mean Accounting Code (at the bottom) or Account Class. Accounting code has no logic for filtering anything out. It should always show ANY that are used regardless. Account class comes from the customer table... so the drop-down is only going to show account classes that existing customers are using.
     
    digitalpoint, Sep 9, 2005 IP
  7. ColinR

    ColinR Guest

    Messages:
    454
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Account Code at the bottom while in the products table is Where it doesn't show up in the list as you add another product and go to set its account code.
     
    ColinR, Sep 9, 2005 IP
  8. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #8
    If you are referring to Accounting Code try doing a recovery on your Products_.fp5 file.
     
    digitalpoint, Sep 9, 2005 IP
  9. ColinR

    ColinR Guest

    Messages:
    454
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #9
    do all users have to be out of Optigold in order to do this?
     
    ColinR, Sep 10, 2005 IP
  10. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #10
    They would need to not be using the Products_.fp5 file at the very least (and closed on your database server).
     
    digitalpoint, Sep 10, 2005 IP