NetSuite Account Register报表详解

发布于:2022-11-09 ⋅ 阅读:(391) ⋅ 点赞:(0)

在前段时间的一次会议上,我们的一名财务顾问展示了Account Register(登记簿)报表的一个参数用途。让我体验到了AHA moment 。原来在这些报表中还有这些我一直忽略的功能。所谓功夫在细处,这又一次指明了我们该往哪里去。所以,今天我们就来细谈这个报表。

首先,我们来辨析一个概念。什么是Account Registers?什么是Register Reports?

下面是对Account Register和Register Report的解释:

An account register is a list of transactions for a particular account, for a selected date range, with the ending balance. NetSuite provides registers for posting and non-posting accounts. Each register includes detailed information about all transactions affecting the account for a selected time period, including balance information.

NetSuite provides several register reports. These reports are different from the single account registers described in Available Account Registers. Each of these reports combines data for all registers of a specific type. The register reports provide more display options than single account registers, but do not provide access to transaction editing or account reconciliation.

讲白了,Account Register是针对“一个”科目的明细账,Register Report是同“一类”科目的明细账。前者不能客制,后者能够客制。并且后者的种类很少,只有如下几种:

•A/P Register Report at Reports > Vendors/Payables > A/P Register
•A/R Register Report at Reports > Customer/Receivables > A/R Register
•Bank Register Report at Reports > Banking/Budgeting > Bank Register
•Estimates Register Report at Reports > Pipeline Analysis > Estimates Register
•Payroll Check Register at Reports > Payroll > Payroll Check Register
•Purchase Order Register Report at Reports > Purchases > Purchase Order Register
•Return Authorizations Register at Reports > Order Management > Return Authorizations Register
•Sales Order Register Report at Reports > Order Management > Sales Orders Register
•Transfer Order Register Report at Reports > Inventory/Items > Transfer Order Register

我们看看两者的差异:

下面的是一个AR科目的Account Register。

下面的是 AR Register Report。

 可以看出差别了吧?科目是一个还是一组,能不能自定义是其主要不同之处。

今天我们细讲Account Register的几个参数。

 如上图红框所示,一个是“1行(1 Line)”,一个是“未结(Open)”。另外,对于银行类科目还有个参数“Uncleared”。总共是3个参数。我们一个个谈。

1行(1 Line)

 “1行”这个参数主要影响报表的布局,可以单行的形式来展现一笔交易。如下图,辨差别:

 

未结(Open)

未结的含义特别模糊,在征询了NetSuite Support的解释后。初步确定为:

  • 对于AP、AR类科目,Open顾名思义,就是是否包含“未结”的AP、AR事务信息。
  • 对于非AP、AR类科目,Open的含义就比较模糊了。如果不勾选Open,则会把涉及此科目的JE类型的事务列示出来,如果勾选Open的话,则屏蔽JE类型的事务。

Uncleared

这个参数只对银行类科目显示,含义明确,就是有没有Reconciled。是否Reconciled,就是看用户有没有勾选Clear。

 这是对Account Register这类报表参数的总结和解释。希望对你也有所启发和帮助。

好好学习,天天向上!

 

本文含有隐藏内容,请 开通VIP 后查看