Shipping Costs in Purchase Orders

chopwoodchopwood Member Posts: 2
edited April 23 in Feedback

What is the purpose of the Shipping Cost field if it can not be reported upon? This has been an issue ever since we have been on Lightspeed. We really need to have a way to run a report on inbound freight / shipping .. OR have the shipping cost be added to the COG's. What is the purpose of the field if it can't be used for accounting purposes? Can this please be a priority feature as it would help all.


Post edited by VanessaD on

9 comments

  • VanessaDVanessaD Moderator, Lightspeed Staff Posts: 643 moderator

    Hey @chopwood ,


    Thank you for the feedback! Currently, the Shipping and Other(+/-) costs cannot be found in reports in retail. They only appear on the PO Ordered Totals under Costs or in the PO total at the top of the Purchase Order.


    I'll note it in the enhancement requests list made by customers!

    ———


    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    All the best!

    Vanessa

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

  • chopwoodchopwood Member Posts: 2

    Yes and it doesn't really make sense to have the field that doesn't get added to the COG's - freight is a factor in COGS and/or an other expense in accounting. Even thought it shows as a 'total' this does not currently get factored into the over all COG's / Profit Margin in lightspeed and it should. Sometimes freight significant in the cost and can change the margins enough to matter. I've made this request a number of times and hopefully we can get this to work out. Right now we have to track it separately to be updated on the accounting side.

  • VanessaDVanessaD Moderator, Lightspeed Staff Posts: 643 moderator

    Hey @chopwood,


    Thank you so much for going into details!

    ———


    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    All the best!

    Vanessa

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

  • JmichaelJmichael Member Posts: 1

    I completely agree with this!

  • LeisureTimeLeisureTime Member Posts: 1

    I agree, Freight plays a major amount in regards to margin. There's a place to put Freight and Discounts, it needs to calculate in to the cost of goods. Or at least give the option for it to calculate.

  • lev_cyclistlev_cyclist Member Posts: 14

    Ever since we started using Lightspeed our purchaser and CFO have been really annoyed by this as well. As others have said on the accounting side shipping costs are part of the Cost of Goods and such should be distributed amongst the cost of the items in the PO.


    Right now we are having to pay someone to manually calculate that and modify each item's cost one at a time, an real abusrdity considering we are in 2021 working with a otherwise powerful tool!

  • Fuzzy_MelonFuzzy_Melon Member Posts: 9

    Oh my LORD I am close to killing myself trying to figure this out. My customer has inventory skewed and I was hoping to get to the P.O. freight-in and discount info in lightspeed so as to manually calculate a per recevied unit, and then apply to goods sold in that time frame. Lightspeed does not offer access to that information in any report or data dump.

    Let's also talk about how I would route that in Lightspeed: If I include discounts and freight-in into the "Asset Inventory" account, it will never be accurate because Lightspeed only sends the "ave cost" (no freight-in or discounts included) for CoGS sales transactions. If I separate freight-in and discounts into exclusive Quickbooks accounts, how do I balance them out with sales transactions?

    Please advise and take me from this ledge, and thank you in advance!

  • amatthamatth Member Posts: 11

    This software was not ready for release. These bugs are not bugs but incomplete software.

  • kellyfkellyf Member Posts: 6

    Agree! This is a big deal in terms of analyzing profit and correctly capturing the activity in our acctg software. We spend a lot of time doing manual calculations that should otherwise be extremely easy to generate via LS reporting.

    At a minimum, it would be incredibly helpful to AT LEAST update the data exports to include Shipping, Other and Discount that are captured in the PO.

Sign In or Register to comment.