最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Tips for naming your Aging Period Definitions

网络文摘 William 1420浏览 0评论

Have you ever created your Aging Period Definitions, run the Customer aging snapshot, and do not receive any results in the Collections Grid? If so, this could be a result of the format used in the Aging Period Definition name.

I have recently discovered that commas in the Aging Period Definition name are treated by SQL as special characters, and cause conflicts when running the Customer aging snapshot. The good news is there is a simple fix to resolve this issue.

Aging Period Definitions are setup under Accounts Receivable > Setup > Collections > Aging period definitions.

Example with commas which produce no results in the Collections grid after running Aging.

Example with underscores which produce results in the Collections grid after running Aging.

If you do not use numbers in the Aging Period Definition and use alpha characters, be sure that no commas exist. The same results will be encountered with alpha characters and commas.

Once you have made the changes to the Aging Period Definition be sure to remove the incorrect one. When running the Customer aging snapshot re-select the Aging period definition. The Customer aging snapshot is run by going to Accounts receivable > Periodic > Collections > Customer aging snapshot.

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址