How to get a supplier report showing details of the transaction

Bronwyn_9084030
Bronwyn_9084030 Member Posts: 27 Reckoner Reckoner
in Accounts Hosted

Hello.. I would like to create a report that shows the allocation of the expense in a supplier transaction. I have selected all the options in the modify report feature, however I cannot select to show the details of the cost allocation, Item and Description. Please help …

allocation.jpg

Answers

  • Alexis McKeown
    Alexis McKeown Reckon Staff Posts: 504 Reckon Staff Reckon Staff

    Dear @Bronwyn_9084030 ,

    I have a few questions so I can try my best to help:

    1. Which report did you initially run?
    2. In the Bill you have there, it seems you only have one item that's being purchased seven times - when you mention allocation, are you meaning the individual cost per item?

    Kind regards,

    Alexis McKeown

    Reckon Senior Technical Support

  • Bronwyn_9084030
    Bronwyn_9084030 Member Posts: 27 Reckoner Reckoner

    Hi Alexis, The bill shows a split of a single charge by the supplier into the number of items. 7x water samples from the lab for that customer job.

    However it is the Expenses or Items with its details that I cannot get to appear on a report.

    allocate.jpg

    I have tried multiple reports by Supplier, and these options do not seem to be available to make visible in a report.

    Are you able to point me to how to create a custom report that will show these details?

    I would like to see this info by Supplier:

    Date
    Bill number
    Expenses (Item)
    Items (Description)
    Customer Job

    This way I can see what the bill was for.

    allocate 2.jpg

    Thanks :)

  • cosmic
    cosmic Reckon Developer Partner Posts: 1,055 Reckon Hall of Famer Reckon Hall of Famer

    Hello Bronwyn

    if this report is needed on a daily basis and its a die hard situation to have it , there is a possibility a external report tool can be developed in real time.

    You can talk to me on 0407068942

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Alexis McKeown
    Alexis McKeown Reckon Staff Posts: 504 Reckon Staff Reckon Staff

    Dear @Bronwyn_9084030 ,

    You may want to try a Purchases by Item Detail report in the Purchases reporting menu.

    You can find it by going into Reports → Purchases → Purchases by Item Detail.

    This report contains most every field you may need for what you're seeking.

    If this does not suit your needs, let me know, and I'll see if I can find another report for you.

    Kind regards,

    Alexis McKeown

    Reckon Senior Technical Support

  • Bronwyn_9084030
    Bronwyn_9084030 Member Posts: 27 Reckoner Reckoner

    The Purchase report is good. Thanks.

  • Alexis McKeown
    Alexis McKeown Reckon Staff Posts: 504 Reckon Staff Reckon Staff

    Dear @Bronwyn_9084030 ,

    I'm glad it worked out for you. 🙂

    If you have any further issues, you're always welcome to post on the Reckon Community.

    Kind regards,

    Alexis McKeown

    Reckon Senior Technical Support

Categories