AR reports and open balances - Dates

[Kim]

I've noticed the the dates for the AR reports and open balances are based off of the Order date.  But our business as I think most business, base the payment due date based on the actual ship date.  So when I look at my "customers with open balances" the dates are not completely true because sometimes we don't have the product to ship or it takes weeks to be built.  It would be nice if the date could be changed to the actual ship date.

I like this report though.. it gives all the needed info. 

One thing I do miss, is not being able to just click on data to take me to the invoice like Quickbooks does.

Kim

[Delphi Centurion]

The "Aged Receivables by Customer" and the "Aged Receiveables by Order Number" reports mirror the same reports in SEOM and use the First [Order Details].DateShipped for an order as the date used for aging your receivables.

The Customer -> Open Balances by Customer and the Financials -> Open Balances by Order reports allow you to choose between Approval or Order Date when calculating aging for your accounts receiveable.

DateShipped is a tricky thing with SEOM and can sometimes give you unexpected results when relying on this date.  For example:  You could have 2 items on a order with 2 different ship dates.  Which date do you use to calculate the aging?  Do you use the first one even though the second item has not shipped and does not have a date, or do you wait for all items to ship before you begin the aging.

At least with the Order or Approval date there is only one date to contend with for any order so using these dates are mopre reliable.  Most customers we work with in circumstances like this wait until an order ships before approving it.

Delphi Centurion

[srl6920]

We ran into this same issue when trying to decide which date to put on our invoices.  We wanted to do approval date but that meant it might be a week from when the last item shipped, so we actually decided to go with order date.  Its not the best solution but billing a week after something ships can dramatically screw up cashflow in a business.

[Kim]

I'm in the Customer with Open Balances report and it appears the Order date and approval date are switched.

I just invoiced an order that shipped, when I run the report with the date as Approval, it shows that the customer is in the 60 days column, but The order approved date is 7/27/2010.  Which tells me something is incorrect with the dates..probably transposed.
Kim

The "Aged Receivables by Customer" and the "Aged Receiveables by Order Number" reports mirror the same reports in SEOM and use the First [Order Details].DateShipped for an order as the date used for aging your receivables.

The Customer -> Open Balances by Customer and the Financials -> Open Balances by Order reports allow you to choose between Approval or Order Date when calculating aging for your accounts receiveable.

DateShipped is a tricky thing with SEOM and can sometimes give you unexpected results when relying on this date.  For example:  You could have 2 items on a order with 2 different ship dates.  Which date do you use to calculate the aging?  Do you use the first one even though the second item has not shipped and does not have a date, or do you wait for all items to ship before you begin the aging.

At least with the Order or Approval date there is only one date to contend with for any order so using these dates are mopre reliable.  Most customers we work with in circumstances like this wait until an order ships before approving it.

Delphi Centurion

[Delphi Centurion]

I'm in the Customer with Open Balances report and it appears the Order date and approval date are switched.

I just invoiced an order that shipped, when I run the report with the date as Approval, it shows that the customer is in the 60 days column, but The order approved date is 7/27/2010.  Which tells me something is incorrect with the dates..probably transposed.
Kim

The "Aged Receivables by Customer" and the "Aged Receiveables by Order Number" reports mirror the same reports in SEOM and use the First [Order Details].DateShipped for an order as the date used for aging your receivables.

The Customer -> Open Balances by Customer and the Financials -> Open Balances by Order reports allow you to choose between Approval or Order Date when calculating aging for your accounts receiveable.

DateShipped is a tricky thing with SEOM and can sometimes give you unexpected results when relying on this date.  For example:  You could have 2 items on a order with 2 different ship dates.  Which date do you use to calculate the aging?  Do you use the first one even though the second item has not shipped and does not have a date, or do you wait for all items to ship before you begin the aging.

At least with the Order or Approval date there is only one date to contend with for any order so using these dates are mopre reliable.  Most customers we work with in circumstances like this wait until an order ships before approving it.

Delphi Centurion

You are right.  The dates are transposed.  It's been fixed and the update will be out in the next release.  Thanks for reporting this issue.

Delphi