电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

支持单据的1级转2级分录并汇总

来源:金蝶云社区作者:金蝶2024-09-232

支持单据的1级转2级分录并汇总

新特性:支持单据的1级转2级分录并汇总

使用说明:

一级分录转1、2级分录

对分录entrys(List)遍历,将源单的物料明细转成1/2级分录

取数脚本:

src.purinvoicesentry = src.entrys.group(material).entries() =>{

  material : key, //物料

  taxamount : value.sum(N amount), //合计

  purinvoicesdetail : value => {

    cmaterial : material, // 物料

    cextaxprice : unitPrice, // 不含税单价

    ctaxrate : taxRate, // 税率

    ctaxprice : taxPrice, // 含税单价

    camountax : taxAmount, // 税额

    invociceqty : quantity, // 发票数量

    cextaxamount : N amount - N taxAmount, // 不含税金额

    ctaxamount : amount, // 含税金额

    id : id // 分录ID

  }

};

二级分录转1级分录

反之,对二级分录进行降级,如对物料cmaterial分组,求和,统计,降为一级分录src.entrys

var src = {

         "taxsum":126.55,

         "supplyinvoiceno":"1",

         "purinvoicesentry":[

                   {

                            "purinvoicesdetail":[

                                     {

                                               "cmaterial":490292061493338112,

                                               "ctaxprice":110.0000000000,

                                               "ctaxamount":1100.00,

                                               "invociceqty":10.0000000000,

                                               "ctaxrate":0.1300000000,

                                               "cextaxamount":973.45,

                                               "id":800473768635276289,

                                               "cextaxprice":97.3451327434,

                                               "camountax":126.55,

                                               "$id":800473768635276289,

                                               "$pk":"id"

                                     },

              {

                                               "cmaterial":122324324,

                                               "ctaxprice":110.0000000000,

                                               "ctaxamount":1100.00,

                                               "in

支持单据的1级转2级分录并汇总

新特性:支持单据的1级转2级分录并汇总使用说明:一级分录转1、2级分录对分录entrys(List)遍历,将源单的物料明细转成1/2级分录取数脚本...
点击下载文档文档为doc格式

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信